if exists (select 1
            from  sysobjects
           where  id = object_id('bd_kq_shift_allowance')
            and   type = 'U')
   drop table bd_kq_shift_allowance
go

/*==============================================================*/
/* Table: bd_kq_shift_allowance                                 */
/*==============================================================*/
create table bd_kq_shift_allowance (
   id                   int                  not null,
   item_no              varchar(30)          not null,
   item_name            varchar(50)          not null,
   least_hours          int                  not null default 0,
   constraint PK_BD_KQ_SHIFT_ALLOWANCE primary key (id)
)
go
